------------------------------------------------------
--created:Son nguyen van
--created_date:23/05/2013
--desc: view category product full
create view v_category_article
as
	select a.category_id,a.images,
		   a.category_status,a.category_sort,
		   a.category_param,a.category_parent,
		   b.category_item_id,
		   b.category_name,b.category_alias,
		   b.category_desc,b.category_desc_short,
		   b.category_title,b.category_meta_keyword,
		   b.category_meta_description,b.category_item_enable,
		   b.language_id
	from tbl_article_category a left outer join tbl_article_category_item b on a.category_id = b.category_id
go

